Transaction Map
|
ID |
Function group |
Function name |
Transaction name |
Transaction description |
G/L |
G/L Ref1 |
G/L Ref2 |
G/L Ref3 |
Notes |
Stock |
Stock change |
Value change |
S/T Ref1 |
S/T Ref2 |
Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
20 |
Accounts payable |
Supplier Invoice |
Supplier Invoice (T) |
|
Yes |
Invoice # |
Line # |
|
|
|
0 |
0 |
|
|
|
|
19 |
Accounts payable |
Supplier Invoice |
Supplier invoice |
|
Yes |
Invoice # |
Line # |
|
|
|
0 |
0 |
|
|
|
|
15 |
Accounts payable |
Receive |
Receive (T) |
|
Yes |
|
|
|
|
|
0 |
0 |
|
|
|
|
35 |
Accounts payable |
Receive |
Receive assignment |
|
Yes |
Receive # |
Line # |
|
|
Yes |
-1 |
-1 |
Receive # |
Line # |
|
|
22 |
Accounts Payable |
Receive return |
Receive return |
|
Yes |
Return # |
Line # |
|
|
Yes |
1 |
1 |
Return # |
Line # |
|
|
21 |
Accounts payable |
Payment |
Payment |
|
Yes |
Payment # |
Line # /1 /2 3 |
|
DIRECT Payments Ref2 = Line # SUPPLIER Payments Ref 2 = 1 (payment amount) Ref 2 = 2 (No ABN witheld amount) Ref 2 = 3 (Voluntary withheld amount) |
|
0 |
0 |
|
|
|
|
4 |
Accounts payable |
Receive |
Receive |
Add items to stock |
Yes |
Receive # |
Line # |
|
|
Yes |
1 |
1 |
Receive # |
Line # |
|
|
2 |
Accounts payable |
Purchase order |
Purchase order |
Puts stock on order |
|
|
|
|
|
Yes |
0 |
0 |
Order # |
Line # |
|
|
17 |
Accounts receivable |
Deposit |
Deposit receipts |
|
Yes |
Deposit # |
Line # |
|
|
|
0 |
0 |
|
|
|
|
16 |
Accounts receivable |
Receipt payment |
Receipt |
|
Yes |
Receipt # |
0 |
|
|
|
0 |
0 |
|
|
|
|
43 |
Accounts receivable |
Dispatch |
Hire adjustment |
|
Yes |
Dispatch # / Return # |
Line # |
|
Ref 1: Dispatch number is used when goods go on hire. Return number is used when goods come back off hire |
Yes |
1 |
1 |
Dispatch # Return # |
Line # |
Ref 1: Dispatch number is used when goods go on hire. Return number is used when goods come back off hire. |
|
48 |
Accounts receivable |
Dispatch |
Sales order uncommit |
|
|
! |
|
|
|
Yes |
0 |
0 |
Dispatch # |
Line # |
|
|
3 |
Accounts receivable |
Dispatch |
Dispatch |
Removes items from stock |
Yes |
Dispatch # |
Line # |
|
|
Yes |
-1 |
-1 |
Dispatch # |
Line # |
|
|
18 |
Accounts receivable |
Dispatch return |
Dispatch return |
|
Yes |
Return # |
Line # |
|
|
Yes |
-1 |
-1 |
Return # |
Line # |
|
|
11 |
Accounts receivable |
Sales invoice |
Invoice (N) |
|
Yes |
Invoice # |
Line # |
|
|
|
0 |
0 |
|
|
|
|
33 |
Accounts receivable |
Sales invoice |
Dispatch (POS) |
|
Yes |
Invoice # |
Line # |
|
|
Yes |
-1 |
-1 |
Invoice # |
Line # |
|
|
1 |
Accounts receivable |
Sales order |
Sales order |
Commits stock |
|
|
|
|
|
Yes |
0 |
0 |
Order # |
Line # |
|
|
41 |
Accounts receivable |
Rebate processing |
Rebate provision |
|
Yes |
Customer # |
-1 |
|
|
|
0 |
0 |
|
|
|
|
12 |
Accounts receivable |
Sales invoice |
Invoice (T) |
|
Yes |
Invoice # |
Line # |
|
|
|
0 |
0 |
|
|
|
|
31 |
Fixed assets |
Asset transaction |
Asset addition |
|
Yes |
|
|
|
|
|
0 |
0 |
|
|
|
|
26 |
Fixed assets |
Asset transaction |
Asset revaluation |
|
Yes |
Asset Trans # |
1 |
|
|
|
0 |
0 |
|
|
|
|
25 |
Fixed assets |
Asset transaction |
Asset disposal |
|
Yes |
Asset Trans # |
1 \ 2\ 3 |
|
3 transactions are performed Ref 2 = 1 (Start cost) Ref 2 = 2 (Total depreciation) Ref 2 = 3 (Disposal value) |
|
0 |
0 |
|
|
|
|
23 |
Fixed assets |
Asset transaction |
Asset depreciation |
|
Yes |
Asset Trans # |
Asset # |
|
|
|
0 |
0 |
|
|
|
|
9 |
General ledger |
Journal entry |
Journal entry |
|
Yes |
Journal Entry # |
Line # |
|
|
|
0 |
0 |
|
|
|
|
36 |
General ledger |
Accounts |
Profit/Loss |
|
Yes |
J E Key |
1 \ 2 |
|
|
|
0 |
0 |
|
|
|
|
13 |
Inventory |
Stocktake |
Stocktake |
|
Yes |
Stocktake # |
Line 3 |
|
|
Yes |
1 |
1 |
Stocktake # |
Line # |
|
|
14 |
Inventory |
Stock transfer |
Stock transfer |
|
Yes |
Stock Xfer # |
Line # |
|
|
Yes |
1 |
1 |
Stock Xfer # |
Line # - Line # |
Two distinct transactions are performed. Transaction using FROM WH: Ref 2 = -Line # Transaction using TO WH: Ref2 = -Line # |
|
38 |
Inventory |
Stock assignment |
Std. Cost Revaluation |
|
Yes |
ST Key |
0 \ 1 |
|
|
Yes |
0 |
1 |
ST Key |
0/1 |
ST Key = Value of ST_Key for original stock transaction For Ref 2: 0 = Any transaction other than Work order done OR Any inventory portion for Work order done 1 = Labour portion for Work order done |
|
32 |
Inventory |
Stock adjustment |
Stock assignment |
|
Yes |
Assignment # |
Line # |
|
|
Yes |
-1 |
-1 |
Assignment # |
Line # |
|
|
27 |
Inventory |
Stock adjustment |
Stock revaluation |
|
Yes |
Revaluation # |
0 |
|
|
Yes |
0 |
1 |
Revaluation # |
0 |
|
|
5 |
Inventory |
Jobs |
Stock Adjustment |
Adjust inventory in or out |
Yes |
Adjustment # |
0 |
|
|
Yes |
1 |
1 |
Adjustment # |
0 |
|
|
40 |
Job costing |
Timesheet |
Job flush |
|
Yes |
Job # |
J E Key |
|
|
|
0 |
0 |
|
|
|
|
39 |
Job costing |
Timesheet |
Timesheet labour |
|
Yes |
Employee # |
Timesheet ID |
WO # |
|
|
0 |
0 |
|
|
|
|
45 |
Job costing |
Work order action |
Timesheet WC costs |
|
Yes |
Employee # |
Hybrid |
|
|
|
0 |
0 |
|
|
|
|
42 |
Manufacturing |
Work order action |
Work Order overheads |
|
Yes |
WO Action ID |
Kit # |
|
|
|
0 |
1 |
WO Action ID |
Kit # |
Kit number refers to the kit being built on the work order |
|
44 |
Manufacturing |
Work order action |
Work Order job costs |
|
Yes |
WO Action ID |
Kit # |
|
|
|
0 |
1 |
WO Action ID |
Kit # |
Kit number refers to the kit being built on the work order |
|
49 |
Manufacturing |
Work order action |
Work Order residual WIP |
|
Yes |
|
|
|
|
Yes |
0 |
1 |
WO Action ID |
Item # |
"Usage mimics that of the other WO costs transactions (eg: TRANSTYPE_WORKORDER_OVERHEADS) in the Item transaction processing. BUT qty is always 1 (0 stock multiplier). WO Finish action: When adding a WO finish and setting WO as complete, WIP value is checked. Any remaining value is now funneled off to the item via this new transaction type. (Uses same accounts as standard WO Done transaction). Note: If there is nothing in stock OR it’s a tracked item and none of the serial numbers for the wo are still in stock, it will raise an error (Nothing to apply the WIP to). " |
|
46 |
Manufacturing |
Work order action |
Work Order WC costs |
|
Yes |
WO Action ID |
Work Centre # |
|
|
|
0 |
1 |
WO Action ID |
Kit # |
Kit number refers to the kit being built on the work order |
|
8 |
Manufacturing |
Work order action |
Work Order Done |
|
Yes |
WO Action ID |
Kit # |
|
|
Yes |
1 |
1 |
WO Action ID |
Kit # |
Kit number refers to the kit being built on the work order |
|
24 |
Manufacturing |
Kit breakdown |
Kit breakdown |
Adds a finished product to stock (stock items only) |
Yes |
Breakdown # |
Kit # / Item # |
|
|
Yes |
1 |
1 |
Breakdown # |
Kit # / Item # |
One transaction for the kit, multiple for the components Transaction for kit: (-Qty) Ref 2 = Kit number Transaction for the components: (+Qty) Ref 2 = Item number |
| 10 |
Manufacturing |
Work order action |
Work Order Create |
|
|
|
|
|
|
Yes |
0 |
0 |
WO Action ID |
Kit # |
Kit number refers to the kit being built on the work order |
|
7 |
Manufacturing |
Work order action |
Work Order Build |
Removes raw materials from stock |
Yes |
WO Action ID |
Item # |
|
|
Yes |
-1 |
-1 |
WO Action ID |
Item # |
Item number refers to an individual component item |
|
37 |
Manufacturing |
Work order action |
Work Order Labour |
|
Yes |
WO Action ID |
Department # |
|
|
Yes |
0 |
1 |
WO Action ID |
Kit # |
Kit number refers to the kit being built on the work order |
|
34 |
Manufacturing |
Repair |
Repairs |
|
Yes |
Repair # |
Line # |
|
|
Yes |
-1 |
-1 |
Repair # |
Line # |
|
|
6 |
Manufacturing |
Work order action |
Work Order Commit |
Commits stock for each of the components in the kit list of the work order |
|
|
|
|
|
Yes |
0 |
0 |
WO Action ID |
Item # |
Item number refers to an individual component item |
|
30 |
Payroll |
Pay run |
Payroll (Leave taken) |
|
Yes |
Pay run # |
Hybrid |
|
|
|
0 |
0 |
|
|
|
|
29 |
Payroll |
Pay run |
Payroll (Leave accrued) |
|
Yes |
Pay run # |
Hybrid |
|
|
|
0 |
0 |
|
|
|
|
28 |
Payroll |
Pay run |
Payroll (Pay) |
|
Yes |
Pay run # |
Hybrid |
|
|
|
0 |
0 |
|
|
|